SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE dbo.[DISC_DefaultDRMStampConfigGetByName]
	@DistributorID varchar(50),
	@Name nvarchar(255),
	@DRMType varchar(20)
AS
BEGIN
	SELECT [ID], [distID], [Name], [Description], [DRMType], [config] FROM [DISC_DefaultDRMStampConfig]
	WHERE [distID] = @DistributorID AND [DRMType] = @DRMType AND [Name] LIKE @Name
END
GO
